SELECT DISTINCT patent.*, YEAR(date) as year FROM patent WHERE (assigned_to = 'Louis Schleip') ORDER BY assigned_to DESC, date, patent, type |
Total of 1 patents found where: Assigned To is 'Louis Schleip';
View a patent by clicking on the patent number. You can sort by any of the columns by clicking on the column name.
T / S | Patent | Date | Description | Patentee | Category | Assigned To |
Louis Schleip | ||||||
U | 359,812 | March 22, 1887 | Insulator for Supporting and Holding Electric Wires Cleat type for holding house wiring |
PENNIE, Henry |
Cleat | 1/2 to Louis Schleip |
Total of 0.02 seconds